If a statement in your SQL procedure raises an SQLWARNING or NOT FOUND condition and if you have declared a handler for the respective condition, DB2 passes control to the corresponding handler. 如果SQL过程中有一个语句发出SQLWARNING或NOTFOUND条件,并且为相应的条件声明了一个处理程序,那么DB2将把控制转移到相应的处理程序。
Note that condition functions are not asynchronously signal-safe and should not be called from a signal handler. 注意,条件函数并不是异步信号安全的,因此不能在信号处理函数中调用。
If a statement raises a condition for which a handler exists, the values of the SQLSTATE and SQLCODE variables are available at the beginning of the handler execution. 如果某条语句发出一个存在处理程序的条件,那么SQLSTATE和SQLCODE变量的值就可以在开始执行处理程序时获得。
Maximum number of active Message Handlers that are allowed ( high load condition). 所允许的活动MessageHandler的最大数量(高负载状态)。
When that condition happen, a handler can choose to handle it, or pass it along to the next handle. 当条件发生时,处理器可以选择去处理它或是把它交给下一个处理器处理。